SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `sun_user`
-- ----------------------------
DROP TABLE IF EXISTS `sun_auth`;
CREATE TABLE `sun_auth` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '角色名',
  `permission` text COMMENT '权限',
  `remark` text COMMENT '备注',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `sun_user_auth`;
CREATE TABLE `sun_user_auth` (
    `id` int(11) unsigned PRIMARY KEY NOT NULL AUTO_INCREMENT,
    `user_id` int(11) unsigned  COMMENT '用户id',
    `auth_id` int(11) unsigned  COMMENT '角色id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `sun_options` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `options` varchar(128) DEFAULT NULL COMMENT '可选项目',
  `type` smallint(6) DEFAULT NULL COMMENT '可选项类型',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sun_user`
-- ----------------------------
-- BEGIN;
-- INSERT INTO `sun_user` VALUES ('1', '李白', '123456##', '1', '13265445555', 'zhangsan@mail.com','综合', '','');
-- COMMIT;

-- BEGIN;
-- INSERT INTO `sun_project` VALUES (
-- '1', 'YGWx项目管理', '系统', 'jetlin', 'TRS',
-- 'http://localhost/projectManage/public/index.php/admin/index/',
-- 'http://localhost/projectManage/public/index.php/admin/index/',
-- '管理员账号',
-- '192.168.3.69', '/projectManage/', 'php', 'thinkphp5.0', 'https://github.com/top-think/framework',
-- '/root/projectManage/', '无关联信息', '管理开发人员以及项目信息', '',''
-- );
-- commit;

SET FOREIGN_KEY_CHECKS = 1;